<?php
/* 
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
include_once('Mysql_connect.inc');//启动连接，连接名：$conn
$isbn = $_GET['isbn'];
//echo $isbn;
echo '<table>';
echo '<tr>';
echo '<th>isbn</th>';
echo '<th>title</th>';
echo '<th>author</th>';
echo '<th>type</th>';
echo '<th>price</th>';
echo '<th>press</th>';
echo '<th>borrowed</th>';
echo '</tr>';
$result = mysqli_query($conn, "SELECT isbn, title, author, type, price, press, borrowed FROM book where isbn = '$isbn' and borrowed ='Y'");
while (($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) != NULL) {
    echo '<tr>';
    echo '<td>' . $row['isbn'] . '</td>';
    echo '<td>' . $row['title'] . '</td>';
    echo '<td>' . $row['author'] . '</td>';
    echo '<td>' . $row['type'] . '</td>';
    echo '<td>' . $row['price'] . '</td>';
    echo '<td>' . $row['press'] . '</td>';
    echo '<td>' . $row['borrowed'] . '</td>';
    echo '</tr>';
}
mysqli_free_result($result);
echo '</table>';
include_once('Mysql_unconnect.inc'); //断开连接
?>
